home *** CD-ROM | disk | FTP | other *** search
/ CD BIT 75 / CD BIT 75.iso / Software / mysql-4.0.22-win / data1.cab / Development / sql-bench / Results / RUN-mysql-NT_4.0 < prev    next >
Encoding:
Text File  |  2004-10-28  |  7.2 KB  |  104 lines
  1. Benchmark DBD suite: 2.12
  2. Date of test:        2001-04-19 13:10:13
  3. Running tests on:    Windows NT Version 4.0
  4. Arguments:
  5. Comments:            2x Pentium III XEON 450MHZ, 512M
  6. Limits from:
  7. Server version:      MySQL 3.23.37
  8.  
  9. alter-table: Total time: 2342 wallclock secs ( 0.91 usr  0.59 sys +  0.00 cusr  0.00 csys =  0.00 CPU)
  10. ATIS: Total time: 69 wallclock secs (23.58 usr 10.26 sys +  0.00 cusr  0.00 csys =  0.00 CPU)
  11. big-tables: Total time: 79 wallclock secs (17.44 usr 18.84 sys +  0.00 cusr  0.00 csys =  0.00 CPU)
  12. connect: Total time: 179 wallclock secs (58.89 usr 48.05 sys +  0.00 cusr  0.00 csys =  0.00 CPU)
  13. create: Total time: 897 wallclock secs (15.94 usr 10.42 sys +  0.00 cusr  0.00 csys =  0.00 CPU)
  14. insert: Total time: 6659 wallclock secs (1143.94 usr 544.92 sys +  0.00 cusr  0.00 csys =  0.00 CPU)
  15. select: Total time: 1556 wallclock secs (127.53 usr 47.33 sys +  0.00 cusr  0.00 csys =  0.00 CPU)
  16. wisconsin: Total time: 28 wallclock secs ( 7.95 usr  5.70 sys +  0.00 cusr  0.00 csys =  0.00 CPU)
  17.  
  18. All 8 test executed successfully
  19.  
  20. Totals per operation:
  21. Operation             seconds     usr     sys     cpu   tests
  22. alter_table_add                     1246.00    0.52    0.22    0.00     992
  23. alter_table_drop                    1043.00    0.27    0.06    0.00     496
  24. connect                               33.00   12.13    9.89    0.00   10000
  25. connect+select_1_row                  39.00   12.91   11.73    0.00   10000
  26. connect+select_simple                 37.00   12.36   12.34    0.00   10000
  27. count                                 36.00    0.03    0.02    0.00     100
  28. count_distinct                        48.00    0.56    0.20    0.00    1000
  29. count_distinct_2                      52.00    0.45    0.27    0.00    1000
  30. count_distinct_big                   205.00   22.49    8.11    0.00     120
  31. count_distinct_group                 145.00    2.67    1.19    0.00    1000
  32. count_distinct_group_on_key           48.00    0.58    0.17    0.00    1000
  33. count_distinct_group_on_key_parts    145.00    3.02    0.94    0.00    1000
  34. count_distinct_key_prefix             39.00    0.52    0.17    0.00    1000
  35. count_group_on_key_parts              40.00    2.73    0.83    0.00    1000
  36. count_on_key                         405.00   22.87    8.23    0.00   50100
  37. create+drop                          134.00    3.78    2.89    0.00   10000
  38. create_MANY_tables                   231.00    3.27    1.58    0.00   10000
  39. create_index                          26.00    0.00    0.00    0.00       8
  40. create_key+drop                      167.00    5.98    2.77    0.00   10000
  41. create_table                           0.00    0.02    0.02    0.00      31
  42. delete_all                            19.00    0.00    0.00    0.00      12
  43. delete_all_many_keys                1431.00    0.00    0.03    0.00       1
  44. delete_big                             0.00    0.00    0.00    0.00       1
  45. delete_big_many_keys                1431.00    0.00    0.03    0.00     128
  46. delete_key                             7.00    1.14    1.42    0.00   10000
  47. drop_index                            27.00    0.00    0.00    0.00       8
  48. drop_table                             0.00    0.00    0.00    0.00      28
  49. drop_table_when_MANY_tables          169.00    1.41    1.42    0.00   10000
  50. insert                               235.00   33.44   47.68    0.00  350768
  51. insert_duplicates                     59.00    9.02   12.91    0.00  100000
  52. insert_key                          1440.00   13.86   11.92    0.00  100000
  53. insert_many_fields                    22.00    0.64    0.45    0.00    2000
  54. insert_select_1_key                    8.00    0.00    0.00    0.00       1
  55. insert_select_2_keys                  12.00    0.00    0.00    0.00       1
  56. min_max                               19.00    0.00    0.02    0.00      60
  57. min_max_on_key                       196.00   37.78   15.60    0.00   85000
  58. multiple_value_insert                  9.00    2.53    0.19    0.00  100000
  59. order_by_big                         101.00   61.84   25.81    0.00      10
  60. order_by_big_key                      93.00   66.86   26.16    0.00      10
  61. order_by_big_key2                     88.00   62.99   24.97    0.00      10
  62. order_by_big_key_desc                 94.00   67.34   25.92    0.00      10
  63. order_by_big_key_diff                 98.00   62.45   25.16    0.00      10
  64. order_by_big_key_prefix               88.00   62.72   25.19    0.00      10
  65. order_by_key2_diff                    11.00    5.53    2.19    0.00     500
  66. order_by_key_prefix                    6.00    2.94    1.08    0.00     500
  67. order_by_range                         9.00    2.92    1.23    0.00     500
  68. outer_join                           120.00    0.00    0.00    0.00      10
  69. outer_join_found                     106.00    0.00    0.00    0.00      10
  70. outer_join_not_found                  56.00    0.03    0.00    0.00     500
  71. outer_join_on_key                     41.00    0.00    0.00    0.00      10
  72. select_1_row                           5.00    1.23    1.69    0.00   10000
  73. select_2_rows                          6.00    1.00    2.20    0.00   10000
  74. select_big                           139.00   80.53   32.12    0.00   10080
  75. select_column+column                   5.00    1.08    1.75    0.00   10000
  76. select_diff_key                      127.00    0.67    0.05    0.00     500
  77. select_distinct                       17.00    4.72    1.78    0.00     800
  78. select_group                          59.00    3.11    1.34    0.00    2911
  79. select_group_when_MANY_tables        196.00    1.48    1.77    0.00   10000
  80. select_join                            4.00    1.41    0.53    0.00     100
  81. select_key                           196.00  103.61   37.28    0.00  200000
  82. select_key2                          205.00   93.56   39.66    0.00  200000
  83. select_key2_return_key               198.00   90.06   35.53    0.00  200000
  84. select_key2_return_prim              203.00   91.61   35.25    0.00  200000
  85. select_key_prefix                    201.00   93.56   39.13    0.00  200000
  86. select_key_prefix_join                18.00   12.05    4.75    0.00     100
  87. select_key_return_key                195.00   89.05   37.13    0.00  200000
  88. select_many_fields                    54.00   16.80   18.40    0.00    2000
  89. select_query_cache                    90.00    5.81    1.91    0.00   10000
  90. select_query_cache2                   91.00    5.55    1.86    0.00   10000
  91. select_range                         186.00   27.06    9.17    0.00     410
  92. select_range_key2                     30.00   10.39    3.47    0.00   25010
  93. select_range_prefix                   28.00   10.19    4.06    0.00   25010
  94. select_simple                          4.00    0.80    1.48    0.00   10000
  95. select_simple_join                     3.00    1.52    0.66    0.00     500
  96. update_big                            66.00    0.00    0.00    0.00      10
  97. update_of_key                         56.00    4.66    6.17    0.00   50000
  98. update_of_key_big                     32.00    0.05    0.11    0.00     501
  99. update_of_primary_key_many_keys      447.00    0.03    0.00    0.00     256
  100. update_with_key                      190.00   27.05   40.97    0.00  300000
  101. update_with_key_prefix                58.00    9.02   13.19    0.00  100000
  102. wisc_benchmark                         9.00    5.77    1.45    0.00     114
  103. TOTALS                              13232.00 1396.03  685.87    0.00 2667247
  104.